CREATE PROCEDURE [dbo].[SearchPDA]
 
    @Code VARCHAR(MAX),
	@Anbar VARCHAR(5)

    
AS
SELECT TOP (50)
       *
FROM KalaId
    INNER JOIN Anbar
        ON Anbar.K_Code = KalaId.K_Code
		AND Anbar.A_Code = @Anbar
		
           
WHERE (
          KalaId.Name1 LIKE  '%'+@Code+'%'
		  AND Active_Flag = 0
        
      );





	  